package com.syq.play.db.entity;

import com.syq.play.db.EntityBase;
/**
 * 创建歌曲数据表类
 * @author ShiYiqiong
 *
 */
public class SongEntity implements EntityBase{
	/**歌曲数据表*/
	public static final String SONG_TABLE="song_table";
	/**主键id*/
	public static final String _ID="_id";
	/**歌曲id*/
	public static final String AUDIO_ID="audio_id";
	/**歌曲地址*/
	public static final String DATA="data";
	/**歌曲文件名*/
	public static final String DISPLAY_NAME="display_name";
	/**歌曲标题*/
	public static final String TITLE="title";
	/**歌曲时长*/
	public static final String DURATION="duration";
	/**歌曲大小*/
	public static final String SIZE="size";
	/**歌手*/
	public static final String ARTIST="artist";
	/**专辑*/
	public static final String ALBUM="album";
	/**本地文件夹*/
	public static final String FOLDER="folder";
	/**播放时间*/
	public static final String PLAY_TIME="play_time";
	/**播放次数*/
	public static final String PLAY_COUNT="play_count";

	public String getCreateTableSql() {
		String sql ="CREATE TABLE " + SONG_TABLE + " ("
                + _ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
                + AUDIO_ID + " INTEGER,"
                + DATA + " NVARCHAR(100),"
                + DISPLAY_NAME + " NVARCHAR(30),"
                + TITLE + " NVARCHAR(30),"
                + DURATION +" LONG  DEFAULT '0' NOT NULL,"
                + SIZE + " LONG  DEFAULT '0' NOT NULL,"
                + ARTIST + " NVARCHAR(30),"
                + ALBUM + " NVARCHAR(30),"
                + FOLDER +" NVARCHAR(80),"
                + PLAY_TIME + " LONG  DEFAULT '-1' NOT NULL,"
                + PLAY_COUNT + " LONG  DEFAULT '0' NOT NULL"
                + " )";
		return sql;
	}

	public String[] getInitTableSql() {
		return null;
	}

	public String[] getUpdateTableSql() {
		return null;
	}

}
